<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Karir di PTSI</title>
<link rel="stylesheet" type="text/css" href="../style/style.css" />
</head>
<?
include("config.php");
$nik	= $HTTP_GET_VARS['nik'];
$show	= $HTTP_GET_VARS['show'];

$sqlH	= mssql_query("SELECT * FROM VKarirPTSI WHERE NIK='$nik' ",$conn);
$rowH	= mssql_fetch_array($sqlH);
?>
<body>
<table style="border:none;" width="100%" border="0">
 <tr>
  <td colspan="2"><? include("../header.php"); ?></td>
 </tr>
 <tr>
  <td valign="top" width="150"><? include("../menu.php"); ?></td>
  <td valign="top">
<?
	if($show == "list_karir")
	{
?>  
  <table width="100%" cellspacing="1">
   <tr>
    <td colspan="10"><b>Daftar KARIR di PT. SURVEYOR INDONESIA</b><br /><br /></td>
   </tr>
   <tr>
    <td width="50">NIK</td>
	<td colspan="9"><?=$rowH[NIK]?></td>
   </tr>
   <tr>
    <td>Nama</td>
	<td colspan="9"><?=$rowH[Nama]?></td>
   </tr>
   <tr>
    <td colspan="10" align="right"><input type="button" class="button" value="Tambah" /></td>
   </tr>
   <tr>
    <td colspan="10"><hr noshade="noshade" size="-2" /></td>
   </tr>
   <tr class="headlist">
    <td width="1%">No.</td>
	<td>No. Surat</td>
	<td>Jenis Surat</td>
	<td>Tanggal Efektif</td>
	<td>Tanggal SKD</td>
	<td>Keterangan</td>
	<td>Divisi</td>
	<td>Lokasi</td>
	<td colspan="2">&nbsp;</td>
   </tr>
<?
$sql	= mssql_query("SELECT ROW_NUMBER() OVER (ORDER BY NIK) AS No, CONVERT(CHAR(12), tgl_efektif, 103) TglEfektif, CONVERT(CHAR(12), tgl_skd, 103) TglSkd, * FROM VKarirPTSI WHERE NIK='$nik' ORDER BY seqno",$conn);
while($row = mssql_fetch_array($sql)){
	echo"
	<tr class=contentlist>
	 <td align=right>$row[No]</td>
	 <td>$row[no_surat]</td>
	 <td>$row[Jenis]</td>	 
	 <td align=right>$row[TglEfektif]</td>	 
	 <td align=right>$row[TglSkd]</td>	 
	 <td>$row[keterangan]</td>	 
	 <td>&nbsp;</td>
	 <td>&nbsp;</td>
	 <td><img src='../images/b_edit.png'></td>
	 <td><img src='../images/b_delete.png'></td>
	<tr>
	";
}
?>
</table>
<?
}
elseif($show == "list_detail")
{
}
?>
</td>
</tr>
<tr>
 <td colspan="2">&nbsp;</td>
</tr>
<tr>
 <td colspan="2" style="border:none;"><? include("../footer.php"); ?></td>
</tr>
</table>

</body>
</html>
